package com.javatest.ajax.app3.dao;

import com.javatest.ajax.app3.bean.Location;
import com.javatest.dao.DaoBase;

import java.util.List;

/**
 * Created with IntelliJ IDEA.
 * Description:
 *
 * @author liuziyang
 * @create 2018-09-04 8:40
 */
public class LocationDao extends DaoBase<Location> implements ILocationDao {
    @Override
    public List<Location> getAllLocations() {
        String sql = "SELECT location_id as locationId, city FROM locations";
        return getForList(sql);
    }
}
